microsoft excel q/a Practice Questions Answers Test with Solutions & More Shortcuts

Question : 36

To add two cells (A1 and A2) together you use the following formula

a) =A1 + A2

b) =Add(AI+A2)

c) together (A 1:A2)

d) AlplusA2

e) None of these

Answer: (a)

Question : 37

In Excel 3-D reference in a formula

a) Cannot be modified

b) Only appears on summary worksheets

c) Limits the formatting options

d) Spans worksheets

Answer: (d)

Question : 38

Excel uniquely identifies cells within a worksheet with a cell name

a) Cell names

b) Column numbers and row letters

c) Column letters and row numbers

d) Cell locator coordinates

e) None of these

Answer: (c)

Question : 39

The Paste Special command lets you copy and paste:

a) Multiply the selection by a copied value

b) Cell comments

c) Formatting options

d) The resulting values of a formula instead of the actual formula

e) None of these

Answer: (d)

Question : 40

Files created with Lotus 1-2-3 have an extension

a) DOC

b) XLS

c) 123

d) WK1

e) None of these

Answer: (c)

IMPORTANT computer mcq EXERCISES

microsoft excel q/a Shortcuts »

Click to Read...

MS excel set 5 Online Quiz

Click to Start..
369 microsoft excel qa based computer MCQ MS excel set 5 question answer with explanation pdf

Recently Added Subject & Categories For All Competitive Exams

New Cloze Test Questions and Answers PDF - IBPS Clerk 2024

The most important Cloze Test questions with detailed answers for upcoming IBPS Clerk prelims 2024. Latest English verbal ability practice MCQs, PDF

13-May-2024 by Careericons

Continue Reading »

Mensuration Aptitude Practice Mcq Questions IBPS Clerk 2024

Most Important Practice Mensuration aptitude multiple choice questions, answers with detailed solutions, PDF beginner to advanced for IBPS Clerk Prelims 2024

11-May-2024 by Careericons

Continue Reading »

Top Clock Aptitude Questions and Answers PDF IBPS Clerk 2024

Recent Important IBPS Clerk Prelims 2024 Aptitude Clock MCQ Questions and answers with easy and logical explanation, PDF. Topic wise Free online practice test

10-May-2024 by Careericons

Continue Reading »

New Time and Distance Aptitude MCQ PDF for IBPS Clerk 2024

Latest Time and Distance multiple choice questions and answers with solution PDF for IBPS Clerk Prelims 2024. Practice Speed Aptitude based Objective Mcq

09-May-2024 by Careericons

Continue Reading »